<?php

/**
 *      [Discuz!] (C)2001-2099 Comsenz Inc.
 *      This is NOT a freeware, use is subject to license terms
 *      $Id: table_mobile_setting.php 31281 2012-08-03 02:29:27Z zhangjie $
 */

if (!defined('IN_DISCUZ')) {
    exit('Access Denied');
}

class table_cloud_product_assess extends discuz_table {

    public function __construct() {
        $this->_table = 'cloud_product_assess';
        $this->_pk = 'cpaid';

        parent::__construct();
    }

    //插入数据库
    public function insert($arr) {
        return DB::insert($this->_table, $arr, true);
    }

    //更新数据库
    public function update($id, $data) {
        $id = intval($id);
        if (!$data) {
            return;
        }
        return DB::update($this->_table, $data, DB::field($this->_pk, $id));
    }

    //查找某条记录
    public function fetch_info($id) {
        $id = intval($id);
        return DB::fetch_first("SELECT * FROM %t WHERE " . $this->_pk . "=%d", array($this->_table, $id));
    }


    //根据产品ID查询所有limt数据
    public function fetch_all_limit($cpid, $start = 0, $limit = 0) {
        return DB::fetch_all('SELECT * FROM ' . DB::table($this->_table) . ' where cpid=' . $cpid .' order by lasttime desc '. DB::limit($start, $limit));
    }

    //根据用户ID查询所有评论数据
    public function fetch_all_user_limit($cuid, $start = 0, $limit = 0) {
        return DB::fetch_all('SELECT * FROM ' . DB::table($this->_table) . ' where cuid=' . $cuid  .' order by lasttime desc '. DB::limit($start, $limit));
    }

    // 删除
    public function delete_by_id($id) {
        return DB::query("DELETE FROM %t WHERE " . $this->_pk . "=%d", array($this->_table, $id));
    }

    //更新支持数
    public function update_supportnum($id) {
        return DB::query("UPDATE FROM " . DB::table($this->_table) . " SET supportnum = supportnum+1  WHERE id =" . $id);
    }

    public function fetch_user_order_info($cuid, $coid, $cpid) {
        return DB::fetch_first("SELECT * FROM " . DB::table($this->_table) . " where cpid= " . $cpid . " and cuid=" . $cuid . " and coid=" . $coid);
    }


    public function fetch_all_area_limit($cuid, $start = 0, $limit = 0) {
        return DB::fetch_all('SELECT * FROM ' . DB::table($this->_table) . ' where cadid=' . $cuid  .' order by lasttime desc '. DB::limit($start, $limit));
    }

    public function fetch_all_area_count($cuid, $start = 0, $limit = 0) {
        return DB::fetch_first('SELECT count(cpaid) as  countNum FROM ' . DB::table($this->_table) . ' where cadid=' . $cuid  );
    }



}